IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'spTfiles_Update')
	BEGIN
		PRINT 'Dropping Procedure spTfiles_Update'
		DROP  Procedure  spTfiles_Update
	END

GO

PRINT 'Creating Procedure spTfiles_Update'
GO
Create Procedure dbo.spTfiles_Update
	( 	  
		@FILENO char(20), 
		@ILPNO char(20) = null, 
		@NBSNO char(20) = null, 
		@FTYPE char(20) = null, 
		@LOCNO char(10) = null, 
		@FSTATUS char(10) = null, 
		@FUSER char(8) = null, 
		@FEMPNO char(10) = null, 
		@FDATETIME DateTime = null, 
		@FTRANDTL char(80) = null, 
		@FCREATED DateTime = null, 
		@FCREATEDBY char(8) = null, 
		@FNOTES varchar(20) = null, 
		@FHOLD56 bit = null, 
		@FNOBD bit = null, 
		@FNOTD bit = null, 
		@FLBLPRT bit = null
	)
AS
  /* 
    ------------------------------------------------------------------------------
    - Change History
    - --------------
    - Date          Description
    ------------------------------------------------------------------------------
    - 9/6/2007    Initial version Updated
    ------------------------------------------------------------------------------
  */

	-- Declare the required variables

	-- Update the required new record
	UPDATE Tfiles
	SET
		ILPNO = @ILPNO, 
		NBSNO = @NBSNO, 
		FTYPE = @FTYPE, 
		LOCNO = @LOCNO, 
		FSTATUS = @FSTATUS, 
		FUSER = @FUSER, 
		FEMPNO = @FEMPNO, 
		FDATETIME = @FDATETIME, 
		FTRANDTL = @FTRANDTL, 
		FCREATED = @FCREATED, 
		FCREATEDBY = @FCREATEDBY, 
		FNOTES = @FNOTES, 
		FHOLD56 = @FHOLD56, 
		FNOBD = @FNOBD, 
		FNOTD = @FNOTD, 
		FLBLPRT = @FLBLPRT		
	WHERE FILENO = @FILENO

	-- Return to calling method
	RETURN
	
GO
